﻿/*
#------------------------------------------------------------------------------
#-- Program Name:	[dbo].[spMSX_msx_groups]
#-- Purpose:		Retrieve the current MSX groups
#--	Last Update:	09/18/2012
#--					For a complete history - please review comments in Version
#--					Control.
#------------------------------------------------------------------------------
*/
CREATE PROCEDURE [dbo].[spMSX_msx_groups]
AS

SET NOCOUNT ON

SELECT		servergroup_id,
			name group_name
FROM		[msdb].[dbo].[systargetservergroups]

UNION

SELECT		NULL, 'Unassigned'

ORDER BY	1

SET NOCOUNT OFF